package com.geyue.common.util;

import java.util.HashMap;
import java.util.List;

/**
 * excel数据封装对象
 * @author lfei
 *
 */
public class ExcelBean implements Comparable<ExcelBean> {
	private int num = 0;// 当前sheet的编号,唯一
	private String name = "测试excel";// excel的名字
	private String sheetName = "sheet名称";// 当前sheet的名称
	private String headerCenter = "测试headerCenter";// headerCenter
	private String[] tableHeader = new String[] { "测试数据" };// 当前sheet的表头
	private List<Object[]> sheetData; // 当前sheet的数据
	private HashMap<Integer, ExcelBean> sheets = null;// 多个sheet情况下使用，如果只有一个sheet，那么请输入为null
	private List<Integer[]> colRow;// 合并单元格的行和列{起始行，列，结束行，列}
	private Integer startRow;//填充数据起始行
	private Integer[] colWidth; //   {列宽(50*100),列宽，列宽..}
	private List<short[]> widthList;//列,宽度
	private String todate;//第二行日期数据
	private int colLength;//列的数量
	private String lastValue;//最后一行数据
	private String exportOrg; // 导出归属。
	
	public String getLastValue() {
		return lastValue;
	}

	public void setLastValue(String lastValue) {
		this.lastValue = lastValue;
	}

	public int getColLength() {
		return colLength;
	}

	public void setColLength(int colLength) {
		this.colLength = colLength;
	}

	public String getTodate() {
		return todate;
	}

	public void setTodate(String todate) {
		this.todate = todate;
	}

	public int getNum() {
		return num;
	}

	public void setNum(int num) {
		this.num = num;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getSheetName() {
		return sheetName;
	}

	public void setSheetName(String sheetName) {
		this.sheetName = sheetName;
	}

	public String[] getTableHeader() {
		return tableHeader;
	}

	public void setTableHeader(String[] tableHeader) {
		this.tableHeader = tableHeader;
	}

	public HashMap<Integer, ExcelBean> getSheets() {
		return sheets;
	}

	public void setSheets(HashMap<Integer, ExcelBean> sheets) {
		this.sheets = sheets;
	}

	public List<Object[]> getSheetData() {
		return sheetData;
	}

	public void setSheetData(List<Object[]> sheetData) {
		this.sheetData = sheetData;
	}

	public int compareTo(ExcelBean o) {
		return this.num - o.num;
	}

	public String getHeaderCenter() {
		return headerCenter;
	}

	public void setHeaderCenter(String headerCenter) {
		this.headerCenter = headerCenter;
	}

	public List<Integer[]> getColRow() {
		return colRow;
	}

	public void setColRow(List<Integer[]> colRow) {
		this.colRow = colRow;
	}

	public Integer getStartRow() {
		return startRow;
	}

	public void setStartRow(Integer startRow) {
		this.startRow = startRow;
	}

	public List<short[]> getWidthList() {
		return widthList;
	}

	public void setWidthList(List<short[]> widthList) {
		this.widthList = widthList;
	}

	/** {列宽(50*100),列宽，列宽..}
	 * @return
	 */
	public Integer[] getColWidth() {
		return colWidth;
	}

	/** {列宽(50*100),列宽，列宽..}
	 * @param colWidth
	 */
	public void setColWidth(Integer[] colWidth) {
		this.colWidth = colWidth;
	}

	public String getExportOrg() {
		return exportOrg;
	}

	public void setExportOrg(String exportOrg) {
		this.exportOrg = exportOrg;
	}

	
	
}
